12345678910111213141516171819 |
- USE [db]
- GO
- /****** ¶ÔÏó: UserDefinedFunction [dbo].[fn_GetStatus2] ½Å±¾ÈÕÆÚ: 11/09/2015 10:26:39 ******/
- SET ANSI_NULLS ON
- GO
- SET QUOTED_IDENTIFIER ON
- GO
- create function [dbo].[fn_GetStatus2](@field varchar(10))
- returns int
- as
- begin
- declare @retval int
- if @field = 'δȡ'
- set @retval = 0
- else
- set @retval = 1
- return @retval
- end
|